Providing analytic support to the precincts and units within the Portland Police Bureau. Including compiling and maintaining datasets; analyzing, tracking, and mapping crime data; determining patterns and trends; identifying geographic areas of concern from a community safety lens; and preparing reports and visualizations to inform police response.
Leveraging Police Bureau database to develop and extract custom datasets for analysis projects. Including writing and troubleshooting SQL code ; and designing and coding stored procedures, functions, tables, and views.
Assisting with the development of datasets and visualizations to support the Police Bureau's open data project. Includes preparation of datasets; creation of visualizations using Tableau; and development of supporting materials including data dictionaries and FAQs.
Researching best practices and emerging trends; reviewing professional literature and maintaining relationships with peers in the analyst profession; integrating research findings to inform data collection processes, analysis design, and development of recommendations.
Requirements :
Experience collecting and processing complex quantitative and qualitative data including working with relational databases and writing SQL code.
Experience with the techniques and software used in crime analysis including statistical analysis and/or geospatial analysis.
Experience utilizing data visualization software (such as Tableau) to present complex technical information effectively.
Experience developing recommendations and communicating complex analytical topics to non-technical audiences, both verbally and in writing.
Ability to work both under limited supervision and as part of a collaborative team to determine methodologies and solve problems.